// sql语句
//sqlMap.js——SQL 语句映射文件，供 API 调用
var sqlMap = {
    userdata: {
        queryByUsername: 'SELECT * FROM username_password WHERE username = ?',
        init:'TRUNCATE TABLE userdata;',
        add: 'INSERT INTO userdata (number, name, post, section, workgroup, position, authority, skills) VALUES (?, ?, ?, ?, ?, ?, ?, ?)',
    },
    logdata:{
        init:'TRUNCATE TABLE log_table;',
        log:'INSERT INTO log_table (name,number, IPaddress, operation_time, table_name, operation_content) VALUES (?,?, ?, ?, ?, ?)',

    }


}
module.exports = sqlMap


